ALTER TABLE `ext_identity_result`
    MODIFY COLUMN `env` varchar (20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'env' AFTER `score`;


ALTER TABLE `real_name_auth_log`
    ADD COLUMN `exq_api` varchar(255) NULL COMMENT 'kyc调用api' AFTER `phone_number`;

ALTER TABLE `real_name_auth`
    ADD COLUMN `exq_api` varchar(255) NULL COMMENT 'kyc调用api' AFTER `phone_number`;

ALTER TABLE `real_name_auth`
    ADD COLUMN `bank_code` varchar(60) NULL COMMENT 'BankCode' AFTER `last_name`;


SET NAMES utf8mb4;
SET
FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for bank_code
-- ----------------------------
DROP TABLE IF EXISTS `bank_code`;
CREATE TABLE `bank_code`
(
    `id`                 int(11) NOT NULL AUTO_INCREMENT,
    `sort`               int(2) NOT NULL DEFAULT '99' COMMENT '排序',
    `onepipe_bank_name`  varchar(120) DEFAULT NULL COMMENT 'onepipeBankName',
    `onepipe_bank_code`  varchar(10)  DEFAULT NULL COMMENT 'onePipeCode',
    `monnify_bank_name`  varchar(120) DEFAULT NULL COMMENT 'MonnifyBankName',
    `monnify_bank_code`  varchar(10)  DEFAULT NULL COMMENT 'MonnifyCode',
    `paystack_bank_name` varchar(120) DEFAULT NULL COMMENT 'payStackBankName',
    `paystack_bank_code` varchar(10)  DEFAULT NULL COMMENT 'payStackCode',
    `okra_bank_name`     varchar(120) DEFAULT NULL COMMENT 'OkraBankName',
    `okra_bank_code`     varchar(10)  DEFAULT NULL COMMENT 'OkraCode',
    `okra_bank_id`       varchar(50)  DEFAULT NULL COMMENT 'OkraBankId',
    `remark`             varchar(255) DEFAULT NULL,
    `state`              varchar(255) DEFAULT '1',
    `update_by`          varchar(255) DEFAULT NULL,
    `update_time`        datetime     DEFAULT NULL,
    `create_by`          varchar(255) DEFAULT NULL,
    `create_time`        datetime     DEFAULT NULL,
    PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=67 DEFAULT CHARSET=utf8 COMMENT='银行编码表';

-- ----------------------------
-- Records of bank_code
-- ----------------------------
BEGIN;
INSERT INTO `bank_code`
VALUES (1, 2, 'Access Bank Nigeria Plc', '044', 'Access bank', '044', 'Access Bank', '044', 'Access Bank', '044',
        '5d6fe57a4099cc4b210bbec0', NULL, '1', NULL, '2021-09-26 15:14:20', NULL, '2021-09-22 16:53:52');
INSERT INTO `bank_code`
VALUES (2, 3, 'Diamond Bank Plc', '063', 'Diamond bank', '063', 'Diamond Bank', '063', 'Diamond Bank', '063',
        '5f63f473d550180010a14bf1', NULL, '1', NULL, '2021-09-26 15:14:21', NULL, '2021-09-22 16:53:52');
INSERT INTO `bank_code`
VALUES (3, 14, 'Ecobank Nigeria', '050', '', '', 'Ecobank Nigeria', '050', 'Ecobank Nigeria', '050',
        '5d6fe57a4099cc4b210bbeae', NULL, '1', NULL, '2021-09-26 15:14:20', NULL, '2021-09-22 16:53:52');
INSERT INTO `bank_code`
VALUES (4, 16, 'Enterprise Bank Plc', '084', '', '', '', '', '', NULL, '', NULL, '0', NULL, NULL, NULL,
        '2021-09-22 16:53:52');
INSERT INTO `bank_code`
VALUES (5, 4, 'Fidelity Bank Plc', '070', 'Fidelity bank', '070', 'Fidelity Bank', '070', 'Fidelity Mobile', '318',
        '5d6fe57a4099cc4b210bbeb0', NULL, '1', NULL, '2021-09-26 15:14:20', NULL, '2021-09-22 16:53:52');
INSERT INTO `bank_code`
VALUES (6, 1, 'First Bank of Nigeria Plc', '011', 'First bank', '011', 'First Bank of Nigeria', '011',
        'First Bank of Nigeria', '011', '5d6fe57a4099cc4b210bbeb1', NULL, '1', NULL, '2021-09-26 15:14:20', NULL,
        '2021-09-22 16:53:52');
INSERT INTO `bank_code`
VALUES (7, 6, 'First City Monument Bank', '214', 'First City Monument Bank Plc', '214', 'First City Monument Bank',
        '214', 'First City Monument Bank', '214', '5d6fe57a4099cc4b210bbeb2', NULL, '1', NULL, '2021-09-26 15:14:20',
        NULL, '2021-09-22 16:53:52');
INSERT INTO `bank_code`
VALUES (8, 0, 'Guaranty Trust Bank Plc', '058', 'GTBank', '058', 'Guaranty Trust Bank', '058', 'Guaranty Trust Bank',
        '058', '5d6fe57a4099cc4b210bbeb3', NULL, '1', NULL, '2021-09-26 15:14:20', NULL, '2021-09-22 16:53:52');
INSERT INTO `bank_code`
VALUES (9, 8, 'Heritaage Banking Company Ltd', '030', 'Heritage bank', '030', 'Heritage Bank', '030', 'Heritage Bank',
        '030', '5d6fe57a4099cc4b210bbeb4', NULL, '1', NULL, '2021-09-26 15:14:20', NULL, '2021-09-22 16:53:52');
INSERT INTO `bank_code`
VALUES (10, 9, 'Jaiz Bank', '301', 'JAIZ BANK', '301', 'Jaiz Bank', '301', 'Jaiz Bank', '301',
        '5fb906f78c486a00b987ec06', NULL, '1', NULL, '2021-09-26 15:14:21', NULL, '2021-09-22 16:53:52');
INSERT INTO `bank_code`
VALUES (11, 10, 'Keystone Bank Ltd', '082', 'Keystone bank', '082', 'Keystone Bank', '082', 'Keystone Bank', '082',
        '5d6fe57a4099cc4b210bbeba', NULL, '1', NULL, '2021-09-26 15:14:20', NULL, '2021-09-22 16:53:52');
INSERT INTO `bank_code`
VALUES (12, 11, 'Mainstreet Bank Plc', '014', '', '', '', '', '', NULL, '', NULL, '0', NULL, NULL, NULL,
        '2021-09-22 16:53:52');
INSERT INTO `bank_code`
VALUES (13, 12, 'Skye Bank Plc', '076', '', '', '', '', '', NULL, '', NULL, '0', NULL, NULL, NULL,
        '2021-09-22 16:53:52');
INSERT INTO `bank_code`
VALUES (14, 13, 'Stanbic IBTC Plc', '039', '', '', 'Stanbic IBTC Bank', '221', 'Stanbic IBTC Bank', '221',
        '5d6fe57a4099cc4b210bbeb6', NULL, '1', NULL, '2021-09-26 15:14:20', NULL, '2021-09-22 16:53:52');
INSERT INTO `bank_code`
VALUES (15, 5, 'Sterling Bank Plc', '232', 'Sterling bank', '232', 'Sterling Bank', '232', 'Sterling Bank', '232',
        '5d6fe57a4099cc4b210bbeb8', NULL, '1', NULL, '2021-09-26 15:14:20', NULL, '2021-09-22 16:53:52');
INSERT INTO `bank_code`
VALUES (16, 15, 'Union Bank Nigeria Plc', '032', 'Union bank', '032', 'Union Bank of Nigeria', '032',
        'Union Bank of Nigeria', '032', '5d6fe57a4099cc4b210bbeb9', NULL, '1', NULL, '2021-09-26 15:14:20', NULL,
        '2021-09-22 16:53:52');
INSERT INTO `bank_code`
VALUES (17, 5, 'United Bank for Africa Plc', '033', 'United Bank For Africa Plc', '033', 'United Bank For Africa',
        '033', 'United Bank For Africa', '033', '5d6fe57a4099cc4b210bbebb', NULL, '1', NULL, '2021-09-26 15:14:20',
        NULL, '2021-09-22 16:53:52');
INSERT INTO `bank_code`
VALUES (18, 17, 'Unity Bank Plc', '215', '', '', 'Unity Bank', '215', 'Unity Bank', '215', '5d6fe57a4099cc4b210bbebd',
        NULL, '1', NULL, '2021-09-26 15:14:20', NULL, '2021-09-22 16:53:52');
INSERT INTO `bank_code`
VALUES (19, 6, 'WEMA Bank Plc', '035', 'Wema bank', '035', 'Wema Bank', '035', 'Wema Bank', '035',
        '5d6fe57a4099cc4b210bbebc', NULL, '1', NULL, '2021-09-26 15:14:20', NULL, '2021-09-22 16:53:52');
INSERT INTO `bank_code`
VALUES (20, 4, 'Zenith Bank International', '057', 'Zenith bank', '057', 'Zenith Bank', '057', 'Zenith Bank', '057',
        '5d6fe57a4099cc4b210bbec2', NULL, '1', NULL, '2021-09-26 15:14:20', NULL, '2021-09-22 16:53:52');
INSERT INTO `bank_code`
VALUES (21, 20, NULL, NULL, 'Rubies Micro-finance Bank', '125', 'Rubies MFB', '125', 'Rubies Bank', '587',
        '5f11487e847b28538bfc6c5f', NULL, '1', NULL, '2021-09-26 15:14:20', NULL, '2021-09-22 16:53:52');
INSERT INTO `bank_code`
VALUES (22, 21, NULL, NULL, NULL, NULL, 'Polaris Bank', '076', 'Polaris Bank', '076', '5d6fe57a4099cc4b210bbeb5', NULL,
        '1', NULL, '2021-09-26 15:14:20', NULL, '2021-09-22 16:53:52');
INSERT INTO `bank_code`
VALUES (23, 22, NULL, NULL, NULL, NULL, 'Standard Chartered Bank', '068', 'Standard Chartered Bank', '068',
        '5d6fe57a4099cc4b210bbeb7', NULL, '1', NULL, '2021-09-26 15:14:20', NULL, '2021-09-22 16:53:52');
INSERT INTO `bank_code`
VALUES (24, 23, NULL, NULL, NULL, NULL, 'ALAT by WEMA', '035A', 'Alat', '035A', '5d6fe57a4099cc4b210bbebe', NULL, '1',
        NULL, '2021-09-26 15:14:20', NULL, '2021-09-22 16:53:52');
INSERT INTO `bank_code`
VALUES (25, 7, NULL, NULL, NULL, NULL, 'Providus Bank', '101', 'Providus Bank', '101', '5d6fe57a4099cc4b210bbebf', NULL,
        '1', NULL, '2021-09-26 15:14:20', NULL, '2021-09-22 16:53:52');
INSERT INTO `bank_code`
VALUES (26, 25, NULL, NULL, NULL, NULL, 'Kuda Bank', '50211', 'Kuda Bank', '611', '5f0cf73e8a8bcc18b8156ad7', NULL, '1',
        NULL, '2021-09-26 15:14:20', NULL, '2021-09-22 16:53:52');
INSERT INTO `bank_code`
VALUES (27, 26, NULL, NULL, NULL, NULL, '', '', 'V Bank', '566', '5fad03e18a795405d628156f', NULL, '0', NULL,
        '2021-09-26 15:14:21', NULL, '2021-09-22 16:53:52');
INSERT INTO `bank_code`
VALUES (28, 27, NULL, NULL, NULL, NULL, 'Titan Bank', '102', 'Titan Trust Bank', '102', '610080715958c61031f37737',
        NULL, '1', NULL, '2021-09-26 15:14:21', NULL, '2021-09-22 16:53:52');
INSERT INTO `bank_code`
VALUES (29, 28, NULL, NULL, NULL, NULL, 'Paga', '100002', 'Paga', '327', '6101a35312015634f5c23adf', NULL, '1', NULL,
        '2021-09-26 15:14:21', NULL, '2021-09-22 16:53:52');
INSERT INTO `bank_code`
VALUES (30, 29, NULL, NULL, NULL, NULL, '', '', 'Paystack', '50150010', '61187bdc92628e026f7ddb5f', NULL, '0', NULL,
        '2021-09-26 15:14:21', NULL, '2021-09-22 16:53:52');
INSERT INTO `bank_code`
VALUES (31, 50, NULL, NULL, NULL, NULL, 'Abbey Mortgage Bank', '801', '', NULL, NULL, NULL, '0', NULL, NULL, NULL,
        '2021-09-22 16:53:52');
INSERT INTO `bank_code`
VALUES (32, 50, NULL, NULL, NULL, NULL, 'Amju Unique MFB', '50926', '', NULL, NULL, NULL, '0', NULL, NULL, NULL,
        '2021-09-22 16:53:52');
INSERT INTO `bank_code`
VALUES (33, 50, NULL, NULL, NULL, NULL, 'ASO Savings and Loans', '401', '', NULL, NULL, NULL, '0', NULL, NULL, NULL,
        '2021-09-22 16:53:52');
INSERT INTO `bank_code`
VALUES (34, 50, NULL, NULL, NULL, NULL, 'Bainescredit MFB', '51229', '', NULL, NULL, NULL, '0', NULL, NULL, NULL,
        '2021-09-22 16:53:52');
INSERT INTO `bank_code`
VALUES (35, 50, NULL, NULL, NULL, NULL, 'Bowen Microfinance Bank', '50931', '', NULL, NULL, NULL, '0', NULL, NULL, NULL,
        '2021-09-22 16:53:52');
INSERT INTO `bank_code`
VALUES (36, 50, NULL, NULL, NULL, NULL, 'Carbon', '565', '', NULL, NULL, NULL, '0', NULL, NULL, NULL,
        '2021-09-22 16:53:52');
INSERT INTO `bank_code`
VALUES (37, 50, NULL, NULL, NULL, NULL, 'CEMCS Microfinance Bank', '50823', '', NULL, NULL, NULL, '0', NULL, NULL, NULL,
        '2021-09-22 16:53:52');
INSERT INTO `bank_code`
VALUES (38, 50, NULL, NULL, NULL, NULL, 'Citibank Nigeria', '023', '', NULL, NULL, NULL, '0', NULL, NULL, NULL,
        '2021-09-22 16:53:52');
INSERT INTO `bank_code`
VALUES (39, 50, NULL, NULL, NULL, NULL, 'Coronation Merchant Bank', '559', '', NULL, NULL, NULL, '0', NULL, NULL, NULL,
        '2021-09-22 16:53:52');
INSERT INTO `bank_code`
VALUES (40, 50, NULL, NULL, NULL, NULL, 'Ekondo Microfinance Bank', '562', '', NULL, NULL, NULL, '0', NULL, NULL, NULL,
        '2021-09-22 16:53:52');
INSERT INTO `bank_code`
VALUES (41, 50, NULL, NULL, NULL, NULL, 'Eyowo', '50126', '', NULL, NULL, NULL, '0', NULL, NULL, NULL,
        '2021-09-22 16:53:52');
INSERT INTO `bank_code`
VALUES (42, 50, NULL, NULL, NULL, NULL, 'Firmus MFB', '51314', '', NULL, NULL, NULL, '0', NULL, NULL, NULL,
        '2021-09-22 16:53:52');
INSERT INTO `bank_code`
VALUES (43, 50, NULL, NULL, NULL, NULL, 'FSDH Merchant Bank Limited', '501', '', NULL, NULL, NULL, '0', NULL, NULL,
        NULL, '2021-09-22 16:53:52');
INSERT INTO `bank_code`
VALUES (44, 50, NULL, NULL, NULL, NULL, 'Globus Bank', '00103', '', NULL, NULL, NULL, '1', NULL, NULL, NULL,
        '2021-09-22 16:53:52');
INSERT INTO `bank_code`
VALUES (45, 50, NULL, NULL, NULL, NULL, 'GoMoney', '100022', '', NULL, NULL, NULL, '0', NULL, NULL, NULL,
        '2021-09-22 16:53:52');
INSERT INTO `bank_code`
VALUES (46, 50, NULL, NULL, NULL, NULL, 'Hackman Microfinance Bank', '51251', '', NULL, NULL, NULL, '0', NULL, NULL,
        NULL, '2021-09-22 16:53:52');
INSERT INTO `bank_code`
VALUES (47, 50, NULL, NULL, NULL, NULL, 'Hasal Microfinance Bank', '50383', '', NULL, NULL, NULL, '0', NULL, NULL, NULL,
        '2021-09-22 16:53:52');
INSERT INTO `bank_code`
VALUES (48, 50, NULL, NULL, NULL, NULL, 'Ibile Microfinance Bank', '51244', '', NULL, NULL, NULL, '0', NULL, NULL, NULL,
        '2021-09-22 16:53:52');
INSERT INTO `bank_code`
VALUES (49, 50, NULL, NULL, NULL, NULL, 'Infinity MFB', '50457', '', NULL, NULL, NULL, '0', NULL, NULL, NULL,
        '2021-09-22 16:53:52');
INSERT INTO `bank_code`
VALUES (50, 50, NULL, NULL, NULL, NULL, 'Kredi Money MFB LTD', '50200', '', NULL, NULL, NULL, '0', NULL, NULL, NULL,
        '2021-09-22 16:53:52');
INSERT INTO `bank_code`
VALUES (51, 50, NULL, NULL, NULL, NULL, 'Lagos Building Investment Company Plc.', '90052', '', NULL, NULL, NULL, '0',
        NULL, NULL, NULL, '2021-09-22 16:53:52');
INSERT INTO `bank_code`
VALUES (52, 50, NULL, NULL, NULL, NULL, 'Links MFB', '50549', '', NULL, NULL, NULL, '0', NULL, NULL, NULL,
        '2021-09-22 16:53:52');
INSERT INTO `bank_code`
VALUES (53, 50, NULL, NULL, NULL, NULL, 'Mayfair MFB', '50563', '', NULL, NULL, NULL, '0', NULL, NULL, NULL,
        '2021-09-22 16:53:52');
INSERT INTO `bank_code`
VALUES (54, 50, NULL, NULL, NULL, NULL, 'Mint MFB', '50304', '', NULL, NULL, NULL, '0', NULL, NULL, NULL,
        '2021-09-22 16:53:52');
INSERT INTO `bank_code`
VALUES (55, 50, NULL, NULL, NULL, NULL, 'PalmPay', '999991', '', NULL, NULL, NULL, '0', NULL, NULL, NULL,
        '2021-09-22 16:53:52');
INSERT INTO `bank_code`
VALUES (56, 50, NULL, NULL, NULL, NULL, 'Parallex Bank', '526', '', NULL, NULL, NULL, '0', NULL, NULL, NULL,
        '2021-09-22 16:53:52');
INSERT INTO `bank_code`
VALUES (57, 50, NULL, NULL, NULL, NULL, 'Parkway - ReadyCash', '311', '', NULL, NULL, NULL, '0', NULL, NULL, NULL,
        '2021-09-22 16:53:52');
INSERT INTO `bank_code`
VALUES (58, 50, NULL, NULL, NULL, NULL, 'Paycom', '999992', '', NULL, NULL, NULL, '0', NULL, NULL, NULL,
        '2021-09-22 16:53:52');
INSERT INTO `bank_code`
VALUES (59, 50, NULL, NULL, NULL, NULL, 'Petra Mircofinance Bank Plc', '50746', '', NULL, NULL, NULL, '0', NULL, NULL,
        NULL, '2021-09-22 16:53:52');
INSERT INTO `bank_code`
VALUES (60, 50, NULL, NULL, NULL, NULL, 'Rand Merchant Bank', '502', '', NULL, NULL, NULL, '0', NULL, NULL, NULL,
        '2021-09-22 16:53:52');
INSERT INTO `bank_code`
VALUES (61, 50, NULL, NULL, NULL, NULL, 'Sparkle Microfinance Bank', '51310', '', NULL, NULL, NULL, '0', NULL, NULL,
        NULL, '2021-09-22 16:53:52');
INSERT INTO `bank_code`
VALUES (62, 50, NULL, NULL, NULL, NULL, 'Suntrust Bank', '100', '', NULL, NULL, NULL, '0', NULL, NULL, NULL,
        '2021-09-22 16:53:52');
INSERT INTO `bank_code`
VALUES (63, 50, NULL, NULL, NULL, NULL, 'TAJ Bank', '302', '', NULL, NULL, NULL, '0', NULL, NULL, NULL,
        '2021-09-22 16:53:52');
INSERT INTO `bank_code`
VALUES (64, 50, NULL, NULL, NULL, NULL, 'TCF MFB', '51211', '', NULL, NULL, NULL, '0', NULL, NULL, NULL,
        '2021-09-22 16:53:52');
INSERT INTO `bank_code`
VALUES (65, 50, NULL, NULL, NULL, NULL, 'VFD Microfinance Bank Limited', '566', '', NULL, NULL, NULL, '0', NULL, NULL,
        NULL, '2021-09-22 16:53:52');
INSERT INTO `bank_code`
VALUES (66, 50, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', NULL, NULL, NULL, NULL);
COMMIT;

SET
FOREIGN_KEY_CHECKS = 1;

ALTER TABLE `ext_gps`
    ADD INDEX `lon-lat`(`latitude`, `longitude`) USING BTREE;